<?php
require_once('mysql_connect.php');

if(strlen($_SESSION['userid']) > 0){
}else{
	header("Location:login.php");
	exit();
}
$letclike = NULL;
if(isset($_GET['letclike'])){
$letclike = trim($_GET['letclike']);
}
if(strlen($letclike) == 1){
}else{
$letclike = "a";
}
$loc ="bytitle";
if($letclike==1){
    $query = "SELECT * FROM movie WHERE LEFT(name,1) REGEXP '^[0-9]' ORDER BY name";
}else{
    $query = "SELECT * FROM movie WHERE name LIKE '" . $letclike . "%' ORDER BY name";
}
$result = @mysql_query($query);
include('top.php');
?>
<TABLE><TR><TD>
<BR><CENTER>
<A HREF="bytitle.php?letclike=1"><FONT FACE="Verdana" size="-1" Color=000000>#</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=a"><FONT FACE="Verdana" size="-1" Color=000000>a</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=b"><FONT FACE="Verdana" size="-1" Color=000000>b</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=c"><FONT FACE="Verdana" size="-1" Color=000000>c</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=d"><FONT FACE="Verdana" size="-1" Color=000000>d</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=e"><FONT FACE="Verdana" size="-1" Color=000000>e</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=f"><FONT FACE="Verdana" size="-1" Color=000000>f</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=g"><FONT FACE="Verdana" size="-1" Color=000000>g</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=h"><FONT FACE="Verdana" size="-1" Color=000000>h</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=i"><FONT FACE="Verdana" size="-1" Color=000000>i</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=j"><FONT FACE="Verdana" size="-1" Color=000000>j</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=k"><FONT FACE="Verdana" size="-1" Color=000000>k</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=l"><FONT FACE="Verdana" size="-1" Color=000000>l</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=m"><FONT FACE="Verdana" size="-1" Color=000000>m</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=n"><FONT FACE="Verdana" size="-1" Color=000000>n</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=o"><FONT FACE="Verdana" size="-1" Color=000000>o</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=p"><FONT FACE="Verdana" size="-1" Color=000000>p</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=q"><FONT FACE="Verdana" size="-1" Color=000000>q</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=r"><FONT FACE="Verdana" size="-1" Color=000000>r</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=s"><FONT FACE="Verdana" size="-1" Color=000000>s</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=t"><FONT FACE="Verdana" size="-1" Color=000000>t</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=u"><FONT FACE="Verdana" size="-1" Color=000000>u</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=v"><FONT FACE="Verdana" size="-1" Color=000000>v</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=w"><FONT FACE="Verdana" size="-1" Color=000000>w</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=x"><FONT FACE="Verdana" size="-1" Color=000000>x</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=y"><FONT FACE="Verdana" size="-1" Color=000000>y</FONT></A><FONT FACE="Verdana" size="-1" Color=000000> | </FONT>
<A HREF="bytitle.php?letclike=z"><FONT FACE="Verdana" size="-1" Color=000000>z</FONT></A></CENTER><BR>
<?php
if(mysql_num_rows($result) > 0){
?>	
<?php
	while($actorrow = mysql_fetch_array($result)){
	echo showmovie($actorrow['id']);	
	}
	?>
<?php
}
?>


</TD></TR></TABLE>
<?php
include('bot.php');
?>